Tabela EpSelfControlNotification

Definicja tabeli EpSelfControlNotification

Name

EpSelfControlNotification

Code

EpSelfControlNotification

Comment

Powiadomienia ktore maja byc wyslane danego dnia


Lista kolumn tabeli EpSelfControlNotification

Name

Code

selfControlNotificationId

selfControlNotificationId

PersonID

PersonID

fireTime

fireTime

channelName

channelName

status

status


Kolumna selfControlNotificationId tabeli EpSelfControlNotification

Definicja kolumny selfControlNotificationId tabeli EpSelfControlNotification

Name

selfControlNotificationId

Code

selfControlNotificationId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID powiadomienia


Kolumna PersonID tabeli EpSelfControlNotification

Definicja kolumny PersonID tabeli EpSelfControlNotification

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID pacjenta


Kolumna fireTime tabeli EpSelfControlNotification

Definicja kolumny fireTime tabeli EpSelfControlNotification

Name

fireTime

Code

fireTime

Data Type

DATE

Mandatory

Yes

Comment

Data i godzinia wyslania przypomnienia


Kolumna channelName tabeli EpSelfControlNotification

Definicja kolumny channelName tabeli EpSelfControlNotification

Name

channelName

Code

channelName

Data Type

VARCHAR2(10)

Mandatory

Yes

Comment

Kanal dla przypomnienia SMS/EMAIL


Kolumna status tabeli EpSelfControlNotification

Definicja kolumny status tabeli EpSelfControlNotification

Name

status

Code

status

Data Type

VARCHAR2(10)

Mandatory

Yes

Comment

Status przypomnienia


Lista kluczy tabeli EpSelfControlNotification

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli EpSelfControlNotification

Definicja klucza Identifier_1 tabeli EpSelfControlNotification

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment